Create KPI's Card 14
How to create KPI's
YOY KPI = [CY Death]/[LY Death]-1
Create Death Per Mth KPI
Death Per Mth = Death per Mth =
Create Total Death KPI
Total Death = Total Death by Fentayl = CALCULATE(COUNT(Fentayl_Drug_Related_Deaths[MannerofDeath])
,FILTER(Fentayl_Drug_Related_Deaths,Fentayl_Drug_Related_Deaths[MannerofDeath] = "Accident"))
KPIs are a great choice:
To measure progress. Answers the question, "What am I ahead or behind on?"
To measure distance to a goal. Answers the question, "How far ahead or behind am I?"
click below link for more information
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi